The Database API > Database API functions > MMDB.showResultset()

 

MMDB.showResultset()

Availability

Dreamweaver UltraDev 1.0

Description

Displays a dialog box with the results of executing the specified SQL statement. The dialog box displays a tabular grid, with the header reflecting the column information and data of the result set generated by the executed stored procedure. If the connection string or the SQL statement is invalid, an error appears. You can use this function to verify the validity of the SQL statement.

Arguments

connName, SQLstatement

connName is an UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source.
SQLstatement is the SQL SELECT statement.

Returns

Nothing. This function returns an error if the SQL statement is invalid or if the connection string is wrong.

Example

The following code displays the results of the executed SQL statement:

MMDB.showResultset("EmpDB","Select EmpName,EmpFirstName,Age from¬
Employees")